The new course brochure July-December 2010 is available online for download
Watch our presentation movie to get an impression of the Oak3 training center.
Course Code
Course Title
# Days
Location
Startdate
Subscribe
OR2072
Oracle: Advanced PL/SQL
3
Kontich - Veldkant 35A - 2550 Kontich - Cronos
29-11-2010
Course Overview:
This course equips students to develop database server-side PL/SQL program units within an Oracle database.
Major subject areas to be explored and secondary objectives are: • Understanding application partitioning within a client/server or multi-tiered web-based systems architecture. • Understanding the basic form and structure of program units stored within the database. • Building and maintaining database-resident program units. • Encapsulating program units within packages and taking advantage of accompanying advanced programming techniques such as cursor variables and cursor expressions. • Handling intricate theoretical challenges, such as mutating tables. • Building and maintaining DML-event and system-event database triggers, including advanced techniques using both simple triggers and compound triggers. • Discuss the storage and execution model for database programs and how one can write efficient programs to maximize performance. • Using system-supplied packages to extend the power of your SQL statements and PL/SQL applications.
Course Topics:
INTRODUCING DATABASE PROGRAM UNITS • ABOUT DATABASE PROGRAM UNITS • TYPES OF PL/SQL PROGRAM UNITS • TYPES OF STORED PROGRAM UNITS • ADVANTAGES OF USING STORED PROGRAM UNITS
ADVANCED CURSOR TECHNIQUES • USING CURSOR VARIABLES • USING CURSOR EXPRESSIONS
USING SYSTEM-SUPPLIED PACKAGES • DBMS_OUTPUT() • UTL_FILE()
REATING DATABASE TRIGGERS • ABOUT DATABASE TRIGGERS • STATEMENT-LEVEL TRIGGERS • ROW-LEVEL TRIGGERS • EXAMPLES OF TRIGGERS • INSTEAD OF TRIGGERS • EMPLOYING TRIGGERS WITHIN AN APPLICATION
MAINTAINING DATABASE TRIGGERS • CALL SYNTAX • TRIGGER MAINTENANCE TASKS • SHOW ERRORS TRIGGER • DROP TRIGGER • ALTER TRIGGER • HANDLING MULTIPLE TRIGGERS FOR A TABLE • HANDLING MUTATING TABLE ISSUES
IMPLEMENTING SYSTEM EVENT TRIGGERS • WHAT ARE SYSTEM EVENT TRIGGERS? • DEFINING THE SCOPE • AVAILABLE SYSTEM EVENTS • SYSTEM EVENT ATTRIBUTES
Course Prerequisites:
Basic course : Oracle : PL/SQL Fundamentals
Course Audience:
Target audience for this course is all Oracle professionals. Among the specific groups for whom this course will be helpful are: • Application designers and developers • Database administrators
